<%@page import="com.sinba.common.utils.TranType"%>
<%@page import="java.util.ArrayList"%>
<%@page import="com.sinba.common.system.dto.SingleGroupReportStatDTO"%>
<%@page import="com.sinba.common.dto.PageDTO"%>
<%@page import="com.sinba.common.system.dto.TransactionRecordDTO"%>
<%@page import="com.sinba.common.system.service.ITransactionRecordService"%>
<%@page import="com.sinba.common.user.service.IAccountService"%>
<%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
<%@page import="org.springframework.context.ApplicationContext"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ include file="../language.jsp" %>
<%
if(session.getAttribute("password2")==null){
	/* response.sendRedirect( "login2.jsp?pageUrl=user/dynamicAccountDetails.jsp");
	return; */
}

ApplicationContext ac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
ITransactionRecordService transactionRecordService = (ITransactionRecordService)ac.getBean("transactionRecordService");
TransactionRecordDTO trDTO = new TransactionRecordDTO();
trDTO.setLoginName((String)session.getAttribute("loginName"));
int pages = 1;
String sidx = "recordId";
String sord="desc";
Object param1 = request.getParameter("trDTO.transactionType");

if(param1!=null 
&& param1!="" 
&& !"null".equals(param1)){
	trDTO.setTransactionType(request.getParameter("trDTO.transactionType"));
	pages=1;
}
if(request.getParameter("pages")!=null && request.getParameter("pages")!=""){
	pages = Integer.parseInt(request.getParameter("pages"));
}
int rows = 10;
int start = ( pages - 1 ) * rows;
trDTO.setStart( start );
trDTO.setLimit( rows );

trDTO.setDtype("Dynamic");
PageDTO pageDTO = transactionRecordService.findTransactionRecordPager(trDTO, sord, sidx);
if(pageDTO!=null){
	pageDTO.setPage( pages );
	pageDTO.setRows( rows );
}
request.setAttribute("pageDTO",pageDTO);

//统计：
Double income = 0D;
TransactionRecordDTO trDto1 = new TransactionRecordDTO();
trDto1.setInOrExp("income");
trDto1.setDtype("Dynamic");
trDto1.setLoginName((String)session.getAttribute("loginName"));
List<SingleGroupReportStatDTO> sgrs = transactionRecordService.statAccount(trDto1);
for(SingleGroupReportStatDTO sgr : sgrs){
	if(sgr.getAggField()!=null){
		income = income+sgr.getAggField();
	}
}
request.setAttribute("income",income);


Double expenditure = 0D;
TransactionRecordDTO trDto2 = new TransactionRecordDTO();
trDto2.setInOrExp("expenditure");
trDto2.setDtype("Dynamic");
trDto2.setTransactionTypes(TranType.DynamicsAccount);
trDto2.setLoginName((String)session.getAttribute("loginName"));
List<SingleGroupReportStatDTO> sgrs2 = transactionRecordService.statAccount(trDto2);
for(SingleGroupReportStatDTO sgr : sgrs2){
	if(sgr.getAggField()!=null){
		expenditure = expenditure+sgr.getAggField();
	}
}
request.setAttribute("expenditure",expenditure);
request.setAttribute("transactionTypes", TranType.DynamicsAccount);

request.setAttribute("pageUrl","dynamicAccountDetails.jsp?loginName="+ trDto1.getLoginName());
session.setAttribute("middle", "财务管理");
session.setAttribute("end", "动态钱包历史");	
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="apple-mobile-web-app-capable" content="yes" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1" >
<title><fmt:message key="i18n.dyMoneyDetail"/>-<fmt:message key="i18n.title"/> </title>
<link rel="shortcut icon" href="../index/favicon.png" />
<script type="text/javascript" src="${basePath}scripts/script.js"></script>
<jsp:include page="common.jsp"></jsp:include>
</head>
<body>
	<jsp:include page="page_head.jsp"></jsp:include>
	<div class="col-md-12">
		<div class="box border primary">
			<div class="box-title">
				<h4><i class="fa fa-bars"></i>动态钱包历史</h4>
			</div>
			<div class="box-body big">
				<h3 class="form-title">
					<fmt:message key="i18n.totalincome"/>:<fmt:formatNumber value="${income}" pattern="#0.0000"/> ，
			<fmt:message key="i18n.totalZhichu"/>：<fmt:formatNumber value="${expenditure}" pattern="#0.0000"/>
				</h3>
				<form class="form-horizontal" role="form" id="bonusSeachForm" action="dynamicAccountDetails.jsp" method="post">
					<input name="sidx" value="recordId" type="hidden" >
					<input name="sord" value="desc" type="hidden" >
					<input name="trDTO.searchType" value="bonus" type="hidden" >
					<input name="trDTO.loginName" value="${session.loginName }" type="hidden" >
					<div class="form-group">
						<label class="col-sm-3 control-label"><fmt:message key="i18n.type"/>：</label>
						<div class="col-sm-9">
						 <select class="form-control" name="trDTO.transactionType">
						  	<option value="">--<fmt:message key="i18n.pelaseSelect"/>--</option>
					 	   	<c:forEach items="${transactionTypes}" var="tts">
					 	   		<option value="${tts}"><fmt:message key="${tts}" /></option>
					 	   	</c:forEach>
						</select>
					  </div>
				  </div>
				  <div class="form-group">
					<label class="col-sm-3 control-label"><fmt:message key="i18n.jiesuanData"/>：</label>
					<div class="col-sm-9">
					  <input type="text" class="form-control" name="trDTO.startTime" placeholder="<fmt:message key="i18n.inputStartTime"/>"/>
					</div>
				  </div>
				  <div class="form-group">
					<label class="col-sm-3 control-label"><fmt:message key="i18n.to"/>：</label>
					<div class="col-sm-9">
					  <input type="text" class="form-control" name="trDTO.endTime" placeholder="<fmt:message key="i18n.inputEndTime" />" />
					</div>
				  </div>
				  <div class="form-group">
					<label class="col-sm-3 control-label"></label>
					<div class="col-sm-9">
					 	 <button class="btn btn-primary" style="width:15em; id="doSeach"><fmt:message key="i18n.serach"/></button>
					</div>
				  </div>
				 </form>
			</div>
			<div class="box-body">
				<div class="tabbable">
					<div class="tab-content">
						<div class="tab-pane active" id="dynamicAccountDetail_tag">
							<table
								class="table table-striped table-bordered table-hover">
								<thead>
									<tr>
										<th><fmt:message key="i18n.type"/></th>
										<th><fmt:message key="i18n.jiaoyiUser"/></th>
										<th><fmt:message key="i18n.income"/></th>
										<th><fmt:message key="i18n.zhichu"/></th>
										<%-- 
										<th><fmt:message key="i18n.balance"/></th>--%>
										<th><fmt:message key="i18n.operationTime"/></th>
										<th><fmt:message key="i18n.remark"/></th>
									</tr>
								</thead>
								<tbody>
								<c:forEach items="${pageDTO.data}" var="data">
						   				<tr>
						   					<td>
												<fmt:message key="${data.transactionType }"/>
											</td>
											<td>${data.transactionObject}</td>
											<td><fmt:formatNumber value="${data.income}" pattern="#0.0000"/></td>
											<td><fmt:formatNumber value="${data.expenditure}" pattern="#0.0000"/></td>
											<%--
											<td><fmt:formatNumber value="${data.balance}" pattern="#0.0000"/></td>--%>
											<td><fmt:formatDate value="${data.optDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
											<td>${data.remark}</td>
						   				</tr>
						   			</c:forEach>
						   			<c:if test="${empty pageDTO.data}">
										<tr>
											<td colspan="6" align="center"><fmt:message key="i18n.noData"/></td>
										</tr>
									</c:if>
									<tr>
											<td colspan="6" style="text-align: right;">
											<a style="color: blue;" href="${pageUrl }&pages=1"><fmt:message key="i18n.firstPage"/></a>
											<c:if test="${pageDTO.page > 1}">
												<a style="color: blue;" href="${pageUrl }&pages=${pageDTO.page-1}"><fmt:message key="i18n.upPage"/></a>
											</c:if>
											<a>${pageDTO.page}/${pageDTO.total}</a>
											<c:if test="${pageDTO.page+1<=pageDTO.total}">
												<a style="color: blue;" href="${pageUrl }&pages=${pageDTO.page+1}"><fmt:message key="i18n.nextPage"/></a>
											</c:if>
											<a style="color: blue;" href="${pageUrl }&pages=${pageDTO.total}"><fmt:message key="i18n.endPage"/></a>
											<a><fmt:message key="i18n.total"/>${pageDTO.totalSize}<fmt:message key="i18n.tiao"/></a>
											</td>
										</tr>
								</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>
	
	<jsp:include page="page_foot.jsp"></jsp:include>
<script>

$(function(){
	//showTransRecord('tr_recommend_table','tr_recommend_pager','recommend',1,10,'optDate','desc');
	//showDirectPushUser('tr_recommendGrid_table','tr_recommendGrid_pager','${user.loginName}',1,10,'registerTime','desc');
    $("#doSeach").click(function(){
    	$("#bonusSeachForm").submit();
    });
})

</script>

</body>
</html>